package com.lzw.breezeNovel.webApp.mapper.video;

import com.lzw.breezeNovel.model.entity.pojo.video.TvEpisode;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author 清风明月
 * @Package com.lzw.breezeNovel.webApp.mapper.video
 * @date 2025/3/20
 * @description
 */
@Mapper
@SuppressWarnings("all")
public interface TvEpisodeMapper {

    /**
     * 根据剧集ID查询剧集信息
     * @param id
     * @return
    */
    @Select("select show_name,episode_number,season_number,description,video_url,cover_image from tv_episode where tv_id = #{id} order by episode_number asc")
    List<TvEpisode> getTvEpisodeById(Integer id);
}
